Resource Consumption Calculation Overview
In order to compare resource consumption across multiple hospitals, common or comparative quantities must be calculated for each hospital. In QualityAdvisor, this process occurs behind the scenes before the data is loaded into the database and at two comparative levels:
- Perspective Standard Charge Master
- Perspective Clinical Detail
The quantity unit conversion process consists of the following three steps:
- Hospital Billing Quantity is converted to Perspective Standard Charge Master Quantity.

- Perspective Standard Charge Master Quantity is then converted to Perspective Clinical Detail Quantity.

-
Total Converted Quantity is calculated for each comparative level by summing the converted quantities for each mapped line item (see example below Step 3: Calculating Total Converted Quantity).
Steps 1 & 2: Calculating Converted Quantity Example
Step 3: Calculating Total Converted Quantity
Total Converted Quantity for Perspective Standard Charge Master:
In the example below, the hospital has a Total Converted Quantity of 792 for Piperacillin, Pipracil VL 3 GM, and 143 for Piperacillin, Pipracil VL 4 GM at the Perspective Standard Charge Master Resource Consumption Comparative level.
|
Piperacillin, Pipracil VL 3 GM |
792 |
|
Piperacillin, Pipracil VL 4 GM |
143 |
In the next example, the hospital has a Total Converted Quantity of 1,474 for Piperacillin, Pipracil VL 2 GM at the Perspective Clinical Detail level.
|
Total converted Quantity Perspective Clinical Detail: |
|
|
Piperacillin, Pipracil VL 2 GM |
143 |
Total Converted Quantity Use within QualityAdvisor
Hospital-specific Total Converted Quantities are stored for each mapped Perspective Standard Charge Master and Perspective Clinical Detail line item within the Perspective Database, where it is called Quantity.
Total Converted Quantity = Quantity in QualityAdvisor
Quantity in QualityAdvisor SPL Resource analyses is included in the Quantity / Resource Case metric. This metric represents the exact resource consumption descriptive line item provided to a specified number of patients over a specified amount of time.
Example: Perspective Clinical Detail Quantity Conversion
For example, a hospital ran an SPL Resources analysis for APR DRG 139 (Other Pneumonia) for the year 2010 that included 24 cases:
|
Perspective Clinical Detail Quantity Conversion |
|
Quantity = 1,474 |
|
Resource Cases = 24 |
|
Quantity / Resource Case = (1,474/24) = 61.42 |
This means that 61.42 units (2 GM vials) of Piperacillin were provided to resource cases with APR DRG 139 for year 2010.
Example : Perspective Standard Charge Master Quantity Conversion
In the following example, the hospital ran a QualityAdvisor analysis for APR DRG 139 for the year 2010 at the Perspective Standard Charge Master level and
found that there were two line items mapped to the Piperacillin VL 2GM drug.
|
Total converted Quantity Perspective Clinical Detail: |
|
|
Piperacillin, Pipracil VL 3 GM |
Piperacillin, Pipracil VL 4 GM |
|
Quantity = 792 |
Quantity = 143 |
|
Resource Cases = 19 |
Resource Cases = 5 |
|
Quantity / Resource Case = (792/19) = 41.68 |
Quantity / Resource Case = (143/5) = 28.60 |
This means that 41.68 units of Piperacillin VL 3GM and 28.60 units of Piperacillin 4GM were provided to Premier Memorial’s cases with APR DRG 139 for year 2000.